# encoding：utf-8
# @File   : read_login_data.py
# @Author : 乖孩子
# @Date   : 2025-05-08 10-09-58
from openpyxl import load_workbook


def read_login_xlsx_data(file_path):
    workbook = load_workbook(file_path)
    sheet = workbook.active
    testdata = []
    for row in sheet.iter_rows(min_row=2, values_only=True):                # 从第二行开始，跳过表头
        username, password = row
        testdata.append((username, password))

    return testdata